package com.kelaite.procurement.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.kelaite.procurement.entity.TPurchaseOrganizationUser;

public interface PurchaseOrganizationUserRepository extends
		JpaRepository<TPurchaseOrganizationUser, Long> {

	@Query(value = "select * from t_purchase_organization_user where purchase_organization_id = ?1 and status = ?2 ", nativeQuery = true)
	public List<TPurchaseOrganizationUser> findByPurchaseOrganizationId(
			Long purOrganazationId, Integer status);

}
